SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetEmployerAccountByName]
    (
      @JOL_Employer_Name VARCHAR(50)
    )
AS 
    SELECT  JOL_Employer_Account
    FROM    dbo.JOL_Employer
    WHERE   JOL_Employer_Name = @JOL_Employer_Name
GO
